﻿CREATE TABLE [investment].[Stock] (
    [MarketIdentifierCode] NVARCHAR (8)   NOT NULL,
    [Code]                 NVARCHAR (8)   NOT NULL,
    [Name]                 NVARCHAR (128) NOT NULL,
    CONSTRAINT [PK_Stock] PRIMARY KEY CLUSTERED ([MarketIdentifierCode] ASC, [Code] ASC),
    CONSTRAINT [FK_Stock_MIC] FOREIGN KEY ([MarketIdentifierCode]) REFERENCES [investment].[MarketIdentifier] ([Code])
);





